SELECT p.* FROM property p INNER JOIN customer c ON p.customerid = c.customerid AND c.archived IS NULL AND c.isDisabled = 0 WHERE LISTINGSTATUS = 'L'AND (p.expirydate IS NULL or p.expirydate > now()) AND highlightAdvertPosition = 0 AND p.ADDRESSPOSTCODE IN (4660,5034,7010,4660,5034,7010,5061,5035,5063,7009,5033,5900,5031,5901,5902,5005,5001,5000,5037,5038,5039,5903,5041,5904,5920,5942,5950,5800,5810,5839,5880,5881,5882,5883,5884,5885,5886,5887,5888,5065,5032,5007,5006,5040,5043,5064,5067,5071,7008,5069,7011,7012) UNION SELECT p.* FROM property p INNER JOIN customer c ON p.customerid = c.customerid AND c.archived IS NULL WHERE p.listingStatus IN ('L')AND c.isDisabled = 0 AND highlightAdvertPosition > 0 AND (p.expirydate IS NULL or p.expirydate > now())AND p.addressstate RLIKE 'QLD|SA|TAS'ORDER BY highlightAdvertPosition DESC